package com.ujs.edu.medicine.dao;

import com.ujs.edu.medicine.dataobject.YunjiayiIdcard;
import java.util.List;

import org.apache.ibatis.annotations.*;
import org.apache.ibatis.type.JdbcType;
@Mapper
public interface YunjiayiIdcardMapper {
    @Delete({
        "delete from yunjiayi_idcard",
        "where id= #{id,jdbcType=INTEGER}"
    })
    int deleteByPrimaryKey(Integer id);

    @Insert({
        "insert into yunjiayi_idcard (id, value)",
        "values (#{id,jdbcType=INTEGER}, #{value,jdbcType=VARCHAR})"
    })
    int insert(YunjiayiIdcard record);

    @Select({
        "select",
        "id, value",
        "from yunjiayi_idcard"
    })
    @Results({
        @Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
        @Result(column="value", property="value", jdbcType=JdbcType.VARCHAR)
    })
    List<YunjiayiIdcard> selectAll();
    @Select("select * from yunjiayi_idcard where id=#{id}")
    YunjiayiIdcard selectByPrimaryKey(@Param("id")Integer id);



}